Supported data types

The table below shows the default mappings from Qlik Replicate data types to JSON and Avro logical data types.

For information on source data type mappings, see the section for the source endpoint you are using.

For additional information about Qlik Replicate data types, see Replicate data types.

Mapping to JSON and Avro

Avro message format uses logical types for a more precise representation of the data type.

Data type mappings
Qlik Replicate Data Types	JSON	Avro
DATE	STRING	DATE Annotates an Avro INT.
TIME	STRING	TIME-MILLIS Annotates an Avro INT.
TIMESTAMP	STRING	TIMESTAMP-MICROS Annotates an Avro LONG.
STRING	STRING	STRING
WSTRING	STRING	STRING
CLOB	STRING	STRING
NCLOB	STRING	STRING
NUMERIC	STRING	DECIMAL (p,s) Annotates an Avro BYTES.
BYTES	STRING (represented as hexadecimal digits)	BYTES
BLOB	STRING (represented as hexadecimal digits)	BYTES
REAL4	NUMBER	FLOAT
REAL8	NUMBER	DOUBLE
INT1	NUMBER	INT
INT2	NUMBER	INT
INT4	NUMBER	INT
INT8	NUMBER	LONG
UINT1	NUMBER	INT
UINT2	NUMBER	INT
UINT4	NUMBER	LONG
UINT8	STRING	DECIMAL (20,0) Annotates an Avro BYTES.
BOOLEAN	BOOLEAN	BOOLEAN

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!